<template>
  <div class="app-container">
    <el-form :model="queryParams" ref="queryForm" size="small" :inline="true" v-show="showSearch" label-width="68px">
      <el-form-item label="批次号" prop="batchNo">
        <el-select v-model="queryParams.batchNo" filterable placeholder="请选择批次号">
          <el-option v-for="dict in batchNoList" :key="dict" :label="dict" :value="dict"></el-option>
        </el-select>
      </el-form-item>
      <!-- <el-form-item label="江苏力冠空调科技有限公司 南通力冠船舶科技有限公司" prop="code">
        <el-input
          v-model="queryParams.code"
          placeholder="请输入江苏力冠空调科技有限公司 南通力冠船舶科技有限公司"
          clearable
          @keyup.enter.native="handleQuery"
        />
      </el-form-item> -->
      <el-form-item>
        <el-button type="primary" icon="el-icon-search" size="mini" @click="handleQuery">搜索</el-button>
        <el-button icon="el-icon-refresh" size="mini" @click="resetQuery">重置</el-button>
      </el-form-item>
    </el-form>

    <el-row :gutter="10" class="mb8">
      <el-col :span="1.5">
        <el-button type="primary" plain icon="el-icon-plus" size="mini" @click="handleAdd"
          v-hasPermi="['gmo:bud:add']">新增</el-button>
      </el-col>
      <el-col :span="1.5">
        <el-button type="success" plain icon="el-icon-edit" size="mini" :disabled="single" @click="handleUpdate"
          v-hasPermi="['gmo:bud:edit']">修改</el-button>
      </el-col>
      <el-col :span="1.5">
        <el-button type="danger" plain icon="el-icon-delete" size="mini" :disabled="multiple" @click="handleDelete"
          v-hasPermi="['gmo:bud:remove']">删除</el-button>
      </el-col>
      <el-col :span="1.5">
        <el-button type="info" plain icon="el-icon-upload2" size="mini" @click="handleImport"
          v-hasPermi="['gmo:bud:importData']">导入</el-button>
      </el-col>
      <el-col :span="1.5">
        <el-button type="warning" plain icon="el-icon-download" size="mini" @click="handleExport"
          v-hasPermi="['gmo:bud:export']">导出</el-button>
      </el-col>
      <right-toolbar :showSearch.sync="showSearch" @queryTable="getList"></right-toolbar>
    </el-row>

    <el-table v-loading="loading" :data="budList" :row-class-name="tableRowClassName"
      @selection-change="handleSelectionChange">
      <el-table-column type="selection" width="55" align="center" />
      <el-table-column label="编码名称" align="center" width="150" prop="code" show-overflow-tooltip />
      <el-table-column label="项目编号" align="center" prop="itemNo" />
      <el-table-column label="支出编号" align="center" prop="expenseCode" />
      <el-table-column label="总计" align="center">
        <el-table-column label="预算" align="center" prop="totalAmount" />
        <el-table-column label="实际" align="center" prop="totalAmountReal" />
      </el-table-column>
      <el-table-column :label="year + '年1月'" align="center">
        <el-table-column label="预算" align="center" prop="jan" />
        <el-table-column label="实际" align="center" prop="janReal" />
      </el-table-column>
      <el-table-column :label="year + '年2月'" align="center">
        <el-table-column label="预算" align="center" prop="feb" />
        <el-table-column label="实际" align="center" prop="febReal" />
      </el-table-column>
      <el-table-column :label="year + '年3月'" align="center">
        <el-table-column label="预算" align="center" prop="mar" />
        <el-table-column label="实际" align="center" prop="marReal" />
      </el-table-column>
      <el-table-column :label="year + '年4月'" align="center">
        <el-table-column label="预算" align="center" prop="apr" />
        <el-table-column label="实际" align="center" prop="aprReal" />
      </el-table-column>
      <el-table-column :label="year + '年5月'" align="center">
        <el-table-column label="预算" align="center" prop="may" />
        <el-table-column label="实际" align="center" prop="mayReal" />
      </el-table-column>
      <el-table-column :label="year + '年6月'" align="center">
        <el-table-column label="预算" align="center" prop="jun" />
        <el-table-column label="实际" align="center" prop="junReal" />
      </el-table-column>
      <el-table-column :label="year + '年7月'" align="center">
        <el-table-column label="预算" align="center" prop="jul" />
        <el-table-column label="实际" align="center" prop="julReal" />
      </el-table-column>
      <el-table-column :label="year + '年8月'" align="center">
        <el-table-column label="预算" align="center" prop="aug" />
        <el-table-column label="实际" align="center" prop="augReal" />
      </el-table-column>
      <el-table-column :label="year + '年9月'" align="center">
        <el-table-column label="预算" align="center" prop="sep" />
        <el-table-column label="实际" align="center" prop="sepReal" />
      </el-table-column>
      <el-table-column :label="year + '年10月'" align="center">
        <el-table-column label="预算" align="center" prop="oct" />
        <el-table-column label="实际" align="center" prop="octReal" />
      </el-table-column>
      <el-table-column :label="year + '年11月'" align="center">
        <el-table-column label="预算" align="center" prop="nov" />
        <el-table-column label="实际" align="center" prop="novReal" />
      </el-table-column>
      <el-table-column :label="year + '年12月'" align="center">
        <el-table-column label="预算" align="center" prop="decem" />
        <el-table-column label="实际" align="center" prop="decemReal" />
      </el-table-column>
      <el-table-column label="操作" align="center" width="120" class-name="small-padding fixed-width" fixed="right">
        <template slot-scope="scope">
          <el-button size="mini" type="text" icon="el-icon-edit" @click="handleUpdate(scope.row)"
            v-hasPermi="['gmo:bud:edit']">修改</el-button>
          <!-- <el-button size="mini" type="text" icon="el-icon-edit" @click="handleDisable(scope.row)"
            v-hasPermi="['gmo:bud:disable']">禁用</el-button>
          <el-button size="mini" type="text" icon="el-icon-delete" @click="handleDisable(scope.row)"
            v-hasPermi="['gmo:bud:disable']">启用</el-button> -->
          <el-button size="mini" type="text" icon="el-icon-delete" @click="handleDelete(scope.row)"
            v-hasPermi="['gmo:bud:remove']">删除</el-button>
        </template>
      </el-table-column>
    </el-table>

    <pagination v-show="total > 0" :total="total" :page.sync="queryParams.pageNum" :limit.sync="queryParams.pageSize"
      @pagination="getList" />

    <!-- 添加或修改公司年度公共预算对话框 -->
    <el-dialog :title="title" :visible.sync="open" width="800px" append-to-body>
      <el-form ref="form" :model="form" :rules="rules" label-width="80px">
        <el-row>
          <el-col :span="12">
            <el-form-item label="编码名称" prop="code">
              <el-input v-model="form.code" placeholder="请输入编码名称" />
            </el-form-item>
          </el-col>
          <el-col :span="12">
            <el-form-item label="项目编号" prop="itemNo">
              <el-input v-model="form.itemNo" placeholder="请输入项目编号" />
            </el-form-item>
          </el-col>
        </el-row>
        <el-row>
          <el-col :span="12">
            <el-form-item label="支出编码" prop="expenseCode">
              <el-input v-model="form.expenseCode" placeholder="请输入支出编码" />
            </el-form-item>
          </el-col>
          <el-col :span="12">
            <el-form-item label="年度" prop="annual">
              <el-date-picker v-model="form.annual" type="year" placeholder="请选择年" style="width: 300px;">
              </el-date-picker>
            </el-form-item>
          </el-col>
        </el-row>
        <el-row>
          <el-col :span="12">
            <el-form-item label="总计预算" prop="totalAmount">
              <el-input v-model="form.totalAmount" placeholder="请输入总计预算" />
            </el-form-item>
          </el-col>
          <el-col :span="12">
            <el-form-item label="总计实际" prop="totalAmountReal">
              <el-input v-model="form.totalAmountReal" placeholder="请输入总计实际" />
            </el-form-item>
          </el-col>
        </el-row>
        <el-row>
          <el-col :span="12">
            <el-form-item label="1月预算" prop="jan">
              <el-input v-model="form.jan" placeholder="请输入1月预算" />
            </el-form-item>
          </el-col>
          <el-col :span="12">
            <el-form-item label="1月实际" prop="janReal">
              <el-input v-model="form.janReal" placeholder="请输入1月实际" />
            </el-form-item>
          </el-col>
        </el-row>
        <el-row>
          <el-col :span="12">
            <el-form-item label="2月预算" prop="feb">
              <el-input v-model="form.feb" placeholder="请输入2月预算" />
            </el-form-item>
          </el-col>
          <el-col :span="12">
            <el-form-item label="2月实际" prop="febReal">
              <el-input v-model="form.febReal" placeholder="请输入2月实际" />
            </el-form-item>
          </el-col>
        </el-row>
        <el-row>
          <el-col :span="12">
            <el-form-item label="3月预算" prop="mar">
              <el-input v-model="form.mar" placeholder="请输入3月预算" />
            </el-form-item>
          </el-col>
          <el-col :span="12">
            <el-form-item label="3月实际" prop="marReal">
              <el-input v-model="form.marReal" placeholder="请输入3月实际" />
            </el-form-item>
          </el-col>
        </el-row>
        <el-row>
          <el-col :span="12">
            <el-form-item label="4月预算" prop="apr">
              <el-input v-model="form.apr" placeholder="请输入4月预算" />
            </el-form-item>
          </el-col>
          <el-col :span="12">
            <el-form-item label="4月实际" prop="aprReal">
              <el-input v-model="form.aprReal" placeholder="请输入4月实际" />
            </el-form-item>
          </el-col>
        </el-row>
        <el-row>
          <el-col :span="12">
            <el-form-item label="5月预算" prop="may">
              <el-input v-model="form.may" placeholder="请输入5月预算" />
            </el-form-item>
          </el-col>
          <el-col :span="12">
            <el-form-item label="5月实际" prop="mayReal">
              <el-input v-model="form.mayReal" placeholder="请输入5月实际" />
            </el-form-item>
          </el-col>
        </el-row>
        <el-row>
          <el-col :span="12">
            <el-form-item label="6月预算" prop="jun">
              <el-input v-model="form.jun" placeholder="请输入6月预算" />
            </el-form-item>
          </el-col>
          <el-col :span="12">
            <el-form-item label="6月实际" prop="junReal">
              <el-input v-model="form.junReal" placeholder="请输入6月实际" />
            </el-form-item>
          </el-col>
        </el-row>
        <el-row>
          <el-col :span="12">
            <el-form-item label="7月预算" prop="jul">
              <el-input v-model="form.jul" placeholder="请输入7月预算" />
            </el-form-item>
          </el-col>
          <el-col :span="12">
            <el-form-item label="7月实际" prop="julReal">
              <el-input v-model="form.julReal" placeholder="请输入7月实际" />
            </el-form-item>
          </el-col>
        </el-row>
        <el-row>
          <el-col :span="12">
            <el-form-item label="8月预算" prop="aug">
              <el-input v-model="form.aug" placeholder="请输入8月预算" />
            </el-form-item>
          </el-col>
          <el-col :span="12">
            <el-form-item label="8月实际" prop="augReal">
              <el-input v-model="form.augReal" placeholder="请输入8月实际" />
            </el-form-item>
          </el-col>
        </el-row>
        <el-row>
          <el-col :span="12">
            <el-form-item label="9月预算" prop="sep">
              <el-input v-model="form.sep" placeholder="请输入9月预算" />
            </el-form-item>
          </el-col>
          <el-col :span="12">
            <el-form-item label="9月实际" prop="sepReal">
              <el-input v-model="form.sepReal" placeholder="请输入9月实际" />
            </el-form-item>
          </el-col>
        </el-row>
        <el-row>
          <el-col :span="12">
            <el-form-item label="10月预算" prop="oct">
              <el-input v-model="form.oct" placeholder="请输入10月预算" />
            </el-form-item>
          </el-col>
          <el-col :span="12">
            <el-form-item label="10月实际" prop="octReal">
              <el-input v-model="form.octReal" placeholder="请输入10月实际" />
            </el-form-item>
          </el-col>
        </el-row>
        <el-row>
          <el-col :span="12">
            <el-form-item label="11月预算" prop="nov">
              <el-input v-model="form.nov" placeholder="请输入11月预算" />
            </el-form-item>
          </el-col>
          <el-col :span="12">
            <el-form-item label="11月实际" prop="novReal">
              <el-input v-model="form.novReal" placeholder="请输入11月实际" />
            </el-form-item>
          </el-col>
        </el-row>
        <el-row>
          <el-col :span="12">
            <el-form-item label="12月预算" prop="decem">
              <el-input v-model="form.decem" placeholder="请输入12月预算" />
            </el-form-item>
          </el-col>
          <el-col :span="12">
            <el-form-item label="12月实际" prop="decemReal">
              <el-input v-model="form.decemReal" placeholder="请输入12月实际" />
            </el-form-item>
          </el-col>
        </el-row>
      </el-form>
      <div slot="footer" class="dialog-footer">
        <el-button type="primary" @click="submitForm">确 定</el-button>
        <el-button @click="cancel">取 消</el-button>
      </div>
    </el-dialog>

    <!-- 公司年度公共预算导入对话框 -->
    <el-dialog :title="upload.title" :visible.sync="upload.open" width="400px" append-to-body>
      <el-upload ref="upload" :limit="1" accept=".xlsx, .xls" action="" :http-request="importData"
        :disabled="upload.isUploading" :on-progress="handleFileUploadProgress" :auto-upload="false" drag>
        <i class="el-icon-upload"></i>
        <div class="el-upload__text">将文件拖到此处，或<em>点击上传</em></div>
        <div class="el-upload__tip text-center" slot="tip">
          <div class="el-upload__tip" slot="tip">
            <el-checkbox v-model="upload.updateSupport" /> 是否更新已经存在的公司年度公共预算数据
          </div>
          <span>仅允许导入xls、xlsx格式文件。</span>
          <el-link type="primary" :underline="false" style="font-size:12px;vertical-align: baseline;"
            @click="importTemplate">下载模板</el-link>
        </div>
      </el-upload>
      <div slot="footer" class="dialog-footer">
        <el-button type="primary" @click="submitFileForm">确 定</el-button>
        <el-button @click="upload.open = false">取 消</el-button>
      </div>
    </el-dialog>
  </div>
</template>

<script>
import { listBud, getBud, delBud, addBud, updateBud, getBatchNo } from "@/api/gmo/bud";
import { getToken } from "@/utils/auth";
import { downBlobFile } from "@/utils/ruoyi";
import axios from 'axios';

export default {
  name: "Bud",
  data() {
    return {
      // 遮罩层
      loading: true,
      // 选中数组
      ids: [],
      // 非单个禁用
      single: true,
      // 非多个禁用
      multiple: true,
      // 显示搜索条件
      showSearch: true,
      // 总条数
      total: 0,
      // 公司年度公共预算表格数据
      budList: [],
      // 弹出层标题
      title: "",
      // 是否显示弹出层
      open: false,
      // 查询参数
      queryParams: {
        pageNum: 1,
        pageSize: 10,
      },
      // 表单参数
      form: {
        itemNo: "公共",
        annual: new Date().getFullYear()
      },
      // 表单校验
      rules: {
        code: [
          { required: true, message: "编码名称不能为空", trigger: "blur" }
        ],
        itemNo: [
          { required: true, message: "项目编号不能为空", trigger: "change" }
        ],
        expenseCode: [
          { required: true, message: "支出编号不能为空", trigger: "blur" }
        ],
        annual: [
          { required: true, message: "年度不能为空", trigger: "blur" }
        ]
      },
      // 用户导入参数
      upload: {
        // 是否显示弹出层（用户导入）
        open: false,
        // 弹出层标题（用户导入）
        title: "",
        // 是否禁用上传
        isUploading: false,
        // 是否更新已经存在的客户数据
        updateSupport: 0,
        // 设置上传的请求头部
        headers: { Authorization: "Bearer " + getToken() },
        // 上传的地址
        url: process.env.VUE_APP_BASE_API + "/gmo/bud/importData"
      },
      year: '',
      batchNoList: []
    };
  },
  created() {
    this.getList();
    this.getBatchNo();
    this.year = this.getCurrentTime();
    this.form.annual = new Date().getFullYear()
  },
  methods: {
    /** 查询公司年度公共预算列表 */
    getList() {
      this.loading = true;
      listBud(this.queryParams).then(response => {
        this.budList = response.rows;
        this.total = response.total;
        this.loading = false;
      });
    },
    /** 查询批次号 */
    getBatchNo() {
      getBatchNo().then(response => {
        this.batchNoList = response.data;
      });
    },
    // 取消按钮
    cancel() {
      this.open = false;
      this.reset();
    },
    // 表单重置
    reset() {
      this.form = {
        id: null,
        createId: null,
        createTime: null,
        modifyId: null,
        modifyTime: null,
        status: null,
        isDel: null,
        createName: null,
        fileUrl: null,
        itemNo: "公共",
        code: null,
        expenseCode: null,
        totalAmount: null,
        annual: null,
        jan: null,
        feb: null,
        mar: null,
        apr: null,
        may: null,
        jun: null,
        jul: null,
        aug: null,
        sep: null,
        oct: null,
        nov: null,
        decem: null
      };
      this.resetForm("form");
    },
    /** 搜索按钮操作 */
    handleQuery() {
      this.queryParams.pageNum = 1;
      this.getList();
    },
    /** 重置按钮操作 */
    resetQuery() {
      this.resetForm("queryForm");
      this.handleQuery();
    },
    // 多选框选中数据
    handleSelectionChange(selection) {
      this.ids = selection.map(item => item.id)
      this.single = selection.length !== 1
      this.multiple = !selection.length
    },
    /** 新增按钮操作 */
    handleAdd() {
      this.reset();
      this.open = true;
      this.title = "添加公司年度公共预算";
    },
    /** 修改按钮操作 */
    handleUpdate(row) {
      this.reset();
      const id = row.id || this.ids
      getBud(id).then(response => {
        this.form = response.data;
        this.open = true;
        this.title = "修改公司年度公共预算";
      });
    },
    /** 提交按钮 */
    submitForm() {
      this.$refs["form"].validate(valid => {
        if (valid) {
          if (this.form.id != null) {
            updateBud(this.form).then(response => {
              this.$modal.msgSuccess("修改成功");
              this.open = false;
              this.getList();
            });
          } else {
            addBud(this.form).then(response => {
              this.$modal.msgSuccess("新增成功");
              this.open = false;
              this.getList();
            });
          }
        }
      });
    },
    /** 删除按钮操作 */
    handleDelete(row) {
      const ids = row.id || this.ids;
      this.$modal.confirm('是否确认删除公司年度公共预算编号为"' + ids + '"的数据项？').then(function () {
        return delBud(ids);
      }).then(() => {
        this.getList();
        this.$modal.msgSuccess("删除成功");
      }).catch(() => { });
    },
    /** 导出按钮操作 */
    handleExport() {
      this.queryParams.id = this.ids.join(",");
      this.download('gmo/bud/export', {
        ...this.queryParams
      }, `公司年度公共预算_${new Date().getTime()}.xlsx`)
    },
    /** 导入按钮操作 */
    handleImport() {
      this.upload.title = "客户导入";
      this.upload.open = true;
    },
    /** 下载模板操作 */
    importTemplate() {
      this.download('gmo/bud/importTemplate', {
      }, `公司年度公共预算_template_${new Date().getTime()}.xlsx`)
    },
    importData(file) {
      const loading = this.$loading({
        lock: true,
        text: '数据导入中...',
        spinner: 'el-icon-loading',
        background: 'rgba(0, 0, 0, 0.7)'
      });
      let formData = new FormData();
      formData.append('file', file.file);
      return axios.post(this.upload.url + '?updateSupport=' + this.upload.updateSupport, formData, {
        headers: this.upload.headers,
        responseType: 'blob'
      }).then(res => {
        loading.close()
        this.handleFileSuccess(res, file);
      }).catch(err => {
        loading.close()
      })
    },
    // 文件上传中处理
    handleFileUploadProgress(event, file, fileList) {
      this.upload.isUploading = true;
    },
    // 文件上传成功处理
    handleFileSuccess(response, file, fileList) {
      this.upload.open = false;
      this.upload.isUploading = false;
      this.$refs.upload.clearFiles();
      if (res.data.type === 'application/json') {
        let reader = new FileReader()
        reader.readAsText(res.data);
        reader.onloadend = () => {
          let rsp = JSON.parse(reader.result);
          if (rsp.code == 200) {
            this.$modal.msgSuccess(rsp.msg);
            this.getList();
          } else {
            this.$modal.msgError(rsp.msg);
          }
        }
      } else {
        this.$modal.msgError("导入错误,请查看回执文件");
        let fileName = file.file.name;
        if (fileName.lastIndexOf(".xls") == fileName.length - 4) {
          fileName = fileName.substring(0, fileName.lastIndexOf(".xls"))
        } else if (fileName.lastIndexOf(".xlsx") == fileName.length - 5) {
          fileName = fileName.substring(0, fileName.lastIndexOf(".xlsx"))
        }
        downBlobFile(downBlobFile(res.data, fileName + "Back.xlsx"));
      }
    },
    // 提交上传文件
    submitFileForm() {
      this.$refs.upload.submit();
    },
    getCurrentTime() {
      // 默认当月
      var nowDate = new Date();
      var date = {
        year: nowDate.getFullYear(),
        month: nowDate.getMonth() + 1,
        day: nowDate.getDate()
      };
      const dayDate =
        date.year;
      var date = new Date();
      return dayDate.toString();
    }
  }
};
</script>
